package com.b511.swpu.cementbackend.entity;

import com.fasterxml.jackson.annotation.JsonIgnore;
import lombok.Getter;
import lombok.Setter;
import lombok.experimental.Accessors;
import org.hibernate.annotations.GenericGenerator;
import org.hibernate.validator.constraints.Range;

import javax.persistence.*;

@Entity
@Getter
@Setter
@Accessors(chain = true)
// 水泥浆实验配方 对应表 CM_SLURRY_EXPERIMENT_FORMULA
public class CM_SlurryExperimentFormula extends BABaseEntity {
    @Id
    @GenericGenerator(name="slurryFormulaGenerator", strategy="uuid")
    @GeneratedValue(generator="slurryFormulaGenerator")
    private String CM_SlurryExperimentFormula_ID;

    @Basic
    @Column(name = "CASINGSIZE")
    private Double casingSize;

    @Basic
    @Column(name = "SLURRYTYPE", length = 50)
    private String slurryType;

    @Basic
    @Column(name = "SLURRYNO", length = 50)
    private String slurryNo;

    @Basic
    @Column(name = "MATERIALEFFECT", length = 50)
    private String materialEffect;

    @Basic
    @Column(name = "MATERIALNAME", length = 50)
    private String materialName;

    @Basic
    @Column(name = "MATERIALDENSITY")
    private Double materialDensity;

    @Basic
    @Column(name = "PURECEMENTPROPORTION")
    private Double pureCementProportion;

    @Basic
    @Column(name = "MIXWATERPROPORTION")
    private Double mixWaterProportion;

    @Basic
    @Column(name = "WEIGHT")
    private Double weight;

    @Basic
    @Column(name = "VOL")
    private Double vol;

    @Basic
    @Column(name = "SAMPLEPLOT", length = 50)
    private String samplePlot;

    @Basic
    @Column(name = "QUAILTYNO", length = 50)
    private String quailtyNo;

    @Basic
    @Column(name = "BA_WELL_ID")
    @JsonIgnore
    private Long ba_well_id;

    @ManyToOne
    @JoinColumn(name="cm_basic_id")
    private CM_Basic basic;


}
